Problem Note 32072: Percent or decimal values for Microsoft Excel data might not import correctly using SASĀ® Enterprise Guide
Certain numeric PC data might not import correctly into SAS Enterprise Guide. This will most likely occur with Microsoft Excel or Microsoft Access data that is either decimal or formatted. For example, an Excel column with a data value like 0.00674064% might by default import into SAS Enterprise Guide as 6.7406361247.
To circumvent the problem, change the Read-In and Display formats in the Import Data task to match that of the data, as in this example, Percent12.10.
Operating System and Release Information
SAS System | SAS Enterprise Guide | Microsoft Windows Server 2003 Datacenter Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Enterprise Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows Server 2003 Standard Edition | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2008-05-16 09:58:52 |
Date Created: | 2008-05-12 15:26:09 |